SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 204280 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 204280 [ RunTime:0.003185s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (473592,916993,10493,913716,181429,676829,803105,453889,590874,676156,840714,471058,544925,363172,406537,729313,684154,687447,14190,56754,401567,952249,131109,1048615,815805,1026343,581493,854291,454621,998019,766194,706904,411548,501738,510789,599938,993375,422245,23639,760309,793407,998829,570607,263771,29980,1041644,814767,517017,355924,570461,882289,130380,84012,364263,160560,769162,345338,955090,643290,151929) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000982s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 204280 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 204280 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000650s ]