SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002313s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 820575 LIMIT 1 [ RunTime:0.001680s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 820575 [ RunTime:0.004740s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (75553,915217,292294,1008474,398750,826716,301013,1025239,587715,229979,602710,731437,298709,929951,163940,85224,844000,424503,283167,971301,982473,600886,134058,1041077,850656,747821,554726,104071,202364,412170,77084,208587,546447,277654,471956,419754,414336,728711,778380,826452,423407,1040134,210939,254822,158411,1047114,313367,498990,45317,974529,379509,790677,148338,610806,586907,394287,848258,1003109,1018533,211738) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003251s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 820575 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 820575 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001045s ]