SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 980410 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 980410 [ RunTime:0.001611s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (654850,786513,784610,117495,758864,655300,675058,639330,408339,341844,999575,691286,192018,803705,595571,508348,864259,623726,572089,825012,944008,414879,117683,785551,453328,216815,1005801,349087,181810,529053,331340,971882,902767,346669,97793,408170,253112,138912,900649,101024,257258,558860,946628,175840,308153,101247,369803,491500,725611,717368,755064,730473,416687,163603,981658,201350,594537,933730,292764,769618) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001055s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 980410 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000623s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 980410 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]