SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001550s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 236713 LIMIT 1 [ RunTime:0.000452s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 236713 [ RunTime:0.002949s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (749701,651545,426570,628333,467516,1002164,988700,951365,773679,19912,884147,808041,784057,461309,172765,853139,202562,374859,786358,81247,759859,452241,177170,229742,720678,260013,726998,51397,26158,52519,537377,259404,943121,1029963,199722,197005,31222,796813,178446,380780,580113,435830,309397,524213,570941,924998,509224,1015332,994741,663523,758651,842197,328419,414361,915920,408176,115870,877845,754783,407132) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001967s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 236713 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001924s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 236713 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001122s ]