SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506061 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506061 [ RunTime:0.001608s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (243028,975143,177501,911931,107354,719513,703016,829611,103516,529902,880978,789066,209946,710576,771418,526821,393830,474039,240933,774896,990430,294870,3374,525636,1003471,638628,837164,544390,323068,375788,458603,668703,61840,87548,455722,1018755,655720,491837,280015,217418,92997,53843,762845,905696,540804,1000427,748759,331895,39236,289198,766876,172792,781257,914184,706097,190104,703958,51702,141849,205902) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506061 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000511s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506061 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]