SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001055s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 314564 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 314564 [ RunTime:0.004167s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (478224,464101,613364,419691,262482,942297,966836,1002752,524988,34490,343285,401638,23987,884779,898082,519203,468952,264819,712721,573757,319153,496003,409312,1025015,43819,955010,852460,627213,425206,567149,881117,792326,940345,254878,198449,96998,307069,1041531,863381,357926,795160,789859,287272,216790,486657,338616,739232,1021144,600422,376941,397401,226671,381722,106055,807207,65404,823090,894662,266830,805217) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 314564 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 314564 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000634s ]