SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 513402 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 513402 [ RunTime:0.003433s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1029292,396173,930354,368417,250742,882008,484918,951158,172834,392717,124741,175605,646959,910301,289162,175841,317620,787140,987585,792053,526157,1037590,78409,287682,552614,989459,968141,586900,776129,791991,271719,747867,997818,557286,90087,894068,954313,913922,662031,379463,709093,972701,1032379,1006869,15224,223720,1039194,543907,30768,673211,126079,1035881,394076,267655,1035141,534975,560830,234939,294175,565508) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 513402 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001046s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 513402 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000630s ]