SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401091 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401091 [ RunTime:0.001561s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (638714,509569,936363,431929,876779,239294,305658,999364,1025696,166379,25050,975100,258938,21832,442341,785041,995252,611172,481526,430234,322693,682695,622540,996914,831678,973376,266210,229186,965759,126084,935912,754339,665543,982562,459687,525772,1021400,8667,223734,674584,118806,646301,581473,861927,530186,348550,162447,955348,386808,1002849,850384,534775,70197,412599,871703,1035487,87869,965575,697553,343993) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000954s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000448s ]