SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 317818 LIMIT 1 [ RunTime:0.001015s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 317818 [ RunTime:0.002097s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (909568,350828,209956,703596,346249,552098,850420,414013,879256,320969,574094,788377,738107,16850,64328,601701,305481,232826,571281,664869,910005,550759,73116,66300,442237,695812,276816,594633,798887,786259,332568,1023069,715828,1037234,364672,79121,627383,402974,1001498,714195,631168,11823,213731,547752,208533,78229,979514,505205,271695,167366,846845,396786,450676,857355,128126,414678,197298,505348,487428,411579) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 317818 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000688s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 317818 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000695s ]