SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001326s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410105 LIMIT 1 [ RunTime:0.000670s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410105 [ RunTime:0.002605s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (530496,121722,642958,885294,752833,785548,899094,93150,678110,818199,608864,662731,824637,542091,572928,414801,1021073,939709,472574,423120,502367,127709,141513,443495,654945,72189,710106,772857,788772,967652,55008,762487,532287,549408,277676,439019,938771,738535,936248,300223,650861,1020824,975429,535264,653168,408440,1014849,839386,330882,852215,359918,1021997,695522,714199,867378,657173,88700,447477,900631,415206) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005174s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410105 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000472s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410105 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001083s ]