SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 348223 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 348223 [ RunTime:0.001656s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (217078,892170,596757,904451,622878,921322,100742,926918,263120,795079,283784,195511,326117,719748,706839,721630,564437,1027777,487996,807635,711205,386876,1045248,434197,339129,84478,362260,124856,203437,134879,687208,826549,112012,966344,767447,403952,1030618,18629,391806,942439,314484,993316,371996,48165,705179,880100,691320,757290,212365,42662,98090,333388,61589,22549,809302,162759,80787,914886,369665,1025178) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 348223 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 348223 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000644s ]