SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 336201 LIMIT 1 [ RunTime:0.000822s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 336201 [ RunTime:0.001756s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (321399,408812,492582,442644,1043326,534608,489525,147032,17679,214611,85436,746733,511572,586582,574392,290284,378324,404056,45442,915273,37854,457189,603580,988335,237238,809028,458038,108047,838985,659486,767158,123084,331684,788222,21844,897481,439817,900131,660036,108361,1043990,451716,453866,1022201,114136,23478,606596,614972,647144,760664,658542,747529,979047,722848,28510,936546,654827,1001638,962854,426478) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 336201 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 336201 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]