SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 480786 LIMIT 1 [ RunTime:0.001087s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 480786 [ RunTime:0.002717s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (923120,451145,798054,956837,449540,434091,1023622,317835,1039434,613641,601448,1045665,683341,78427,396892,1029852,107358,1001172,439400,169984,448465,448091,334967,815256,138445,338665,932595,840306,516618,316392,225697,913946,436015,173991,539898,579558,89464,643906,214756,231354,194094,308497,33964,728582,30333,137774,990672,322518,528869,156980,659707,131753,1004203,486331,522169,735422,948895,449313,684331,111903) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.013690s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 480786 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000498s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 480786 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001117s ]