SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001359s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200950 LIMIT 1 [ RunTime:0.000801s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200950 [ RunTime:0.001767s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (403554,816717,522789,39879,334561,16933,825115,69884,163543,68246,882233,515297,777461,733004,233223,814545,241287,610041,878658,268989,58473,772702,215676,637757,884520,747330,374344,162133,727881,128974,787956,222725,93339,263074,214361,407163,50825,326735,894976,148604,722406,629165,857860,229733,605006,682671,816320,743904,670009,524438,468415,973910,292713,232329,87283,798534,93161,5011,807146,366431) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200950 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200950 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000739s ]