SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 496062 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 496062 [ RunTime:0.002745s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (333063,356388,397237,809344,272654,801379,867351,747574,355679,950309,535439,25558,75418,80085,325062,1034960,293835,614014,359584,446905,333868,627187,504006,508841,51717,842378,569979,650582,601378,547166,709072,495440,388160,733837,1045138,725601,496856,122079,493359,338812,836720,1011077,589399,206231,197952,205799,736176,537762,507200,116278,299360,392687,184790,378158,7686,1032054,1023366,8413,427910,819905) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 496062 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 496062 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]