SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001332s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023528 LIMIT 1 [ RunTime:0.000470s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023528 [ RunTime:0.002372s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (793693,874791,477720,168532,718863,86623,109854,513421,930441,53699,759910,733459,660559,548053,808036,44313,499332,878691,356261,416078,265741,191941,899575,546141,373062,998141,921339,973973,389273,860819,1029690,326849,189940,706316,689666,6816,243465,719871,863742,343229,243369,669064,240037,16316,236062,333937,575189,716829,838648,447587,203041,880652,367342,491743,480032,294469,249623,505495,156215,625898) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000976s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023528 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023528 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000494s ]