SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 428639 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 428639 [ RunTime:0.001956s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (539401,114529,97847,152080,319864,471000,330142,154861,386753,473220,984768,268194,737326,250840,630807,580756,585796,712205,653807,723993,766620,415596,220354,291788,390474,785259,52914,619486,1044246,442813,19674,106829,955625,141856,367580,35599,128700,806093,937925,185130,421700,742543,647626,530494,612333,932520,3840,497372,224775,674987,667980,1029196,226472,948571,645286,565396,625256,745655,311529,880133) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 428639 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 428639 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000632s ]