SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 319102 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 319102 [ RunTime:0.001757s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (935626,24941,790125,401460,729493,1015032,734525,357946,484496,335719,338407,65414,664687,1030553,438460,77674,59942,658642,993442,147428,902432,558125,163876,867868,790282,399531,539298,991938,979621,677622,325986,956247,596379,856969,28783,1031893,1011972,362814,557184,725157,591369,385356,510212,280691,637573,703866,982170,293750,779431,752099,444100,474382,464580,278558,786489,553326,244961,159895,407131,744527) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 319102 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 319102 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]