SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001592s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 565951 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 565951 [ RunTime:0.001606s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (721860,403128,923227,755328,838735,1025905,980629,702305,911355,255196,320718,37855,735320,912265,71335,348676,474567,741640,735697,946439,162167,683027,169385,115943,462451,752104,490012,464034,895307,527862,820166,999395,909095,1016792,1045572,907617,904572,751644,633002,877496,317827,987039,844544,110595,133922,692180,229442,132948,1037723,951333,409637,81676,672202,290402,17131,853427,507550,764877,922271,600090) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 565951 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 565951 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000437s ]