SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003016s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415200 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415200 [ RunTime:0.002000s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (115386,550157,1025305,567813,889308,1024120,185108,753874,598307,643655,291571,792880,643938,255917,800603,574175,142342,27837,683786,130559,507604,450917,804783,913994,1030230,388556,985900,98409,877255,160604,198663,94473,158101,127914,210534,149598,447150,689074,481024,489136,756230,930113,152863,17506,811683,80207,911514,884823,1010816,303949,30329,915888,224467,348255,902888,1012201,628062,739470,858740,800197) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002687s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415200 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000758s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415200 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]