SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405100 LIMIT 1 [ RunTime:0.000276s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405100 [ RunTime:0.002106s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (139684,690637,984173,798873,427512,164089,710559,299153,430816,43001,558769,861110,46091,526903,750886,801116,940547,543149,93549,531780,1022105,233927,459274,453101,169516,458568,909260,485301,929464,345929,751090,327591,873495,144914,709861,243168,887496,948994,1001723,621143,447198,54412,458589,841120,324100,35821,884664,498218,530730,437020,571134,482501,472010,824109,351965,127058,1004924,991851,257813,777815) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000987s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405100 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405100 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000507s ]