SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401043 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401043 [ RunTime:0.003788s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (319312,241561,268309,464681,275133,207734,446421,152867,706,69304,215916,34,850479,964484,992387,203685,789223,442410,366729,164335,812517,20072,725495,630525,799687,644046,331732,841466,924956,124005,246361,210435,504204,419315,182053,186849,214183,582539,713846,807855,660370,896631,208462,380827,899824,373985,277428,186244,649061,680743,84809,567421,365284,146435,42971,423724,451995,961180,715963,1014380) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001089s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]