SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 397710 LIMIT 1 [ RunTime:0.000429s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 397710 [ RunTime:0.001658s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (488508,754127,847375,533978,952921,910859,571124,769307,128209,159991,46799,974226,678634,115455,414617,125331,236998,49840,1044084,638393,143793,941132,851372,67313,223253,878599,103260,823482,566229,460157,483690,813518,270629,723122,161185,38251,563154,73981,715385,954042,372513,932714,111533,361975,981195,61361,767935,1015219,478397,648045,593316,1016796,200242,792053,125786,427726,910254,70706,121826,109706) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 397710 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000485s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 397710 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]