SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 985212 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 985212 [ RunTime:0.003027s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (296051,419841,464271,900971,422347,519417,362950,731506,927255,894980,137742,528994,794619,52745,500293,206487,494439,186413,943230,794315,568836,994067,692773,799222,390303,489900,15477,930075,371358,332832,806028,536415,154490,115315,864452,171842,793485,99015,799432,144247,630304,543784,766600,367869,351697,407741,166901,893301,944253,250959,347736,675204,150718,403217,110603,504939,851942,946478,477862,350443) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 985212 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000500s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 985212 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000422s ]