SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545309 LIMIT 1 [ RunTime:0.000438s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545309 [ RunTime:0.003741s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (336703,694523,313483,938207,859812,456859,1048609,274126,800414,926465,891759,682733,851970,1022207,1038070,1037955,496077,978299,752009,985441,1017629,668012,923789,89561,847931,49891,742671,525741,84404,1008668,170756,172727,45922,792421,162352,949680,1177,364051,227614,685846,344115,117779,107247,829294,404569,291461,549023,667897,828900,447289,579810,59538,882386,723284,179876,819854,447637,917116,125843,715132) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003655s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545309 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000559s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545309 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]