SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 241010 LIMIT 1 [ RunTime:0.000286s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 241010 [ RunTime:0.001736s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (962259,117250,510485,748008,217988,105990,158072,961235,408937,139678,568336,456382,864424,797635,220923,122617,591986,233005,504176,373110,874291,196670,604741,980226,832970,1031411,359900,606058,137942,674115,377564,100074,438688,332012,795948,532172,644612,819746,459838,353664,939327,933260,236473,1035370,467359,685780,374863,122946,712095,568334,277983,599257,636427,172540,1040585,980661,610440,378299,394933,930436) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 241010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 241010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]