SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001752s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 452341 LIMIT 1 [ RunTime:0.000423s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 452341 [ RunTime:0.002274s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (765819,26566,501028,116476,297102,531355,936852,232587,180285,753944,365396,502847,699004,704999,456350,275478,70966,538625,809825,122109,981694,947740,391431,492959,808692,260445,27674,680329,877600,1001603,200406,216235,839694,623603,371028,506337,250578,45432,625421,642474,555388,99858,894131,894043,60743,833311,437227,394544,506823,925025,28721,299677,641977,387450,735810,186840,453907,703257,431587) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003496s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 452341 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000495s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 452341 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000649s ]