SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001823s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 385245 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 385245 [ RunTime:0.002689s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1005153,1030659,371794,1011480,312575,496106,978182,1030768,106308,925513,706098,795900,943406,485280,1039605,806247,382166,198532,302763,718888,41325,812189,786814,920021,302805,115329,983316,582602,9665,681368,244375,250315,352883,982143,465730,314347,925607,150364,697702,493899,334822,776486,880493,623740,84829,463326,164300,583373,366482,1012969,344189,769699,927443,621426,96558,73170,160042,747737,249382,623917) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007654s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 385245 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000625s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 385245 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000671s ]