SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 107364 LIMIT 1 [ RunTime:0.001261s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 107364 [ RunTime:0.002768s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (483697,602172,147289,498100,688464,978791,940455,746018,370477,301803,128717,35777,18532,618317,923180,111416,921423,828117,726570,372720,545908,87003,24081,382956,691319,395139,550643,817028,648794,945853,267097,733577,185763,290262,886131,234380,563629,315789,585404,961788,111104,791839,832150,11662,433695,175616,250207,579585,782661,729435,135530,946769,1028483,141789,4121,588525,1044428,1017443,860004,1011276) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 107364 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 107364 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]