SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 564691 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 564691 [ RunTime:0.002208s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (903282,126528,9565,847900,396805,800921,921420,1026827,680948,514130,208377,553554,309183,384698,942026,380851,182749,967472,401321,212659,269034,620048,944000,370232,694801,133630,398742,917575,524738,522289,989243,960325,37379,367545,902026,568581,562923,137846,397390,659720,162547,528168,541769,527223,532452,402305,407733,329103,165914,432323,875812,1001446,391800,495252,334120,807811,270467,533418,938663,267998) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 564691 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000605s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 564691 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000759s ]