SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405527 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405527 [ RunTime:0.002396s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (675667,1005768,165228,364431,338940,699818,135260,137856,592545,12094,131428,570016,470464,723274,1034147,191183,356314,614103,621217,838477,819276,144517,15412,77080,783210,827733,94546,619118,449683,66200,490140,9936,879772,27171,666457,419136,49483,178232,277822,868505,339200,1018056,631775,3566,895109,732667,633930,530315,471872,83423,383330,743476,387423,784950,882409,630890,1027108,441786,1042454,793742) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001886s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405527 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001591s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405527 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000498s ]