SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003183s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 285010 LIMIT 1 [ RunTime:0.003972s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 285010 [ RunTime:0.002517s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (810643,310848,419181,1021967,135312,623387,237347,670846,880295,148899,715201,624172,68159,211584,245387,371843,946003,158099,645972,107799,1020651,200227,628447,240647,537931,789231,717628,677849,176619,921727,889577,481213,231256,639892,467847,805464,1010976,448360,258457,973553,420537,157316,38274,26014,22912,4873,794186,662312,475867,292012,738033,543997,317924,391664,792182,515700,1032128,511373,825736,795940) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 285010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000525s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 285010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000627s ]