SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001842s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405079 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405079 [ RunTime:0.001842s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (522011,643911,565629,439328,582964,276880,137299,525488,997364,369465,336274,471416,873755,172122,292688,662093,322813,638624,18263,567763,6936,512756,250715,233286,1023289,491930,492713,121022,108478,422672,959926,774023,33035,717040,700226,85760,860523,724676,79859,800827,558923,980749,1036339,418279,95007,356880,1010276,639683,750325,386222,250888,935071,216957,964297,293830,598893,1006657,965415,630828,39290) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000974s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405079 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405079 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000898s ]