SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 482455 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 482455 [ RunTime:0.001783s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (282621,780167,54174,213671,669924,784025,208579,286458,577287,508186,99596,226688,554579,778808,188430,754504,381175,779424,950867,794663,497928,558077,101743,543765,1018943,84045,762109,242936,816867,651009,137982,518859,725923,775660,155649,194437,999819,762954,702418,50875,822697,19529,243636,237067,1046774,407555,644037,240354,705224,201975,516778,358687,48015,555921,525723,418344,628186,789371,596780,191730) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 482455 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 482455 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000477s ]