SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001340s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 386616 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 386616 [ RunTime:0.001574s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (971973,695920,7954,120788,742447,800591,841832,1030588,886360,170645,302196,197719,405026,1017010,37712,819051,100620,302747,94701,321987,111024,712861,237707,338010,891726,586776,991360,467938,415614,242060,675279,126226,147359,83470,225190,528678,722975,561359,675973,180898,308419,907021,1013523,948925,921736,274809,203928,593581,53799,458690,326665,159802,477012,677728,223672,827885,578689,84656,848770,262759) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001055s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 386616 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 386616 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000672s ]