SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001401s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042846 LIMIT 1 [ RunTime:0.000505s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042846 [ RunTime:0.002571s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (275461,695324,726532,694950,336644,360039,129913,420756,342775,528258,879513,786658,337098,395915,829526,806623,686748,577807,2370,565662,1019036,802599,766084,441300,780328,946245,992150,529804,467981,588331,762585,594933,1020814,873401,697890,150150,12690,872420,115466,152167,177779,917774,924328,902419,736294,49019,552215,197724,414109,193067,39963,795171,857593,273018,880852,1008575,530796,903418,10901,493913) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042846 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000605s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042846 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.006390s ]