SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 515025 LIMIT 1 [ RunTime:0.000290s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 515025 [ RunTime:0.001552s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (250076,64450,665253,865995,247211,19744,392950,786682,763106,603287,213596,883058,435880,832004,361229,953780,135843,861837,600991,160300,101512,286406,895752,940344,500616,48664,374858,340914,404256,265363,89204,284835,688399,251985,701800,492217,34586,705567,296440,503432,584720,685451,722295,1003271,777179,154444,677084,761841,582056,135692,688738,52674,802336,518825,303824,365959,130757,321278,843179,121128) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 515025 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 515025 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]