SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 154651 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 154651 [ RunTime:0.001727s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1046643,530993,250364,57722,253941,481279,442025,482455,273666,943765,436740,925172,732457,838300,663028,941543,298203,547472,707571,920432,350306,164415,174876,318163,154144,445895,944297,485951,132470,759924,588470,780869,982779,120788,804110,454271,247477,754334,584154,259972,366111,503601,289484,943981,874370,330413,577050,779339,710070,569680,1047274,738835,168158,882903,1007291,546002,457525,486064,503813,749334) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002903s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 154651 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 154651 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]