SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 150178 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 150178 [ RunTime:0.002502s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (392552,1043012,847489,500522,354133,820480,106747,358781,629376,462853,633183,105212,891033,722518,817642,134604,548820,232482,912424,330398,999808,814047,602835,1005875,226290,230962,848237,886648,440409,72390,215658,883785,289098,442084,585876,408006,323849,133148,516532,331163,111283,386797,626979,233476,902045,107147,510414,532840,207563,633914,476548,854275,500539,567375,594457,205409,933925,240942,994827,799868) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 150178 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 150178 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000705s ]