SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 519388 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 519388 [ RunTime:0.002148s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (310324,77993,949581,491423,802177,833548,976311,1022797,450171,14653,527582,517591,46866,945058,360997,296165,771800,623270,423049,1006977,698037,739690,575915,227647,703652,370400,33998,186631,980029,152463,733131,557604,210094,474480,484139,553132,520805,387967,321804,514090,983019,10693,305207,812912,166538,980933,668153,934324,384453,853942,455620,1016080,594653,1033818,858095,115906,763870,801773,993598,544029) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 519388 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 519388 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000710s ]