SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 472621 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 472621 [ RunTime:0.001871s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1004074,611448,309020,575285,1013656,1007790,46342,89787,841533,617934,926109,902391,417801,691799,363186,416480,91973,25625,423182,765667,465066,831404,963997,753387,295222,291474,617430,362256,565584,682383,474570,504361,986393,745120,966078,843222,289665,46610,411382,885254,956465,183601,317090,843941,888646,889490,667525,32086,548656,545599,233717,632018,339116,922283,319258,694082,467700,999666,164443,902702) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 472621 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 472621 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000494s ]