SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410071 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410071 [ RunTime:0.001645s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (775260,855271,580992,134490,736625,825455,929672,409880,909568,318196,810095,494796,576054,218391,630725,920288,660600,378309,332932,570713,910785,652936,19932,566591,81439,984624,294031,1028345,628375,119282,624533,441940,649020,998467,315272,598969,119414,868436,468886,526023,559157,713014,800743,267590,180084,247982,380075,665273,719244,258625,166314,432570,860216,969539,691202,935827,574901,791931,310729,1040273) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410071 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410071 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]