SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 42946 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 42946 [ RunTime:0.001863s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (643861,654271,703486,733053,176118,384353,457371,955514,347623,273863,394809,553497,376728,939364,567700,379544,34682,524891,108532,393920,798130,403894,724499,580995,367797,661470,462287,104886,726903,882387,153039,610208,742803,2589,441904,523472,29665,932306,198968,894090,344445,205986,980664,346275,484444,590972,597213,325251,385811,590619,127744,966705,255630,427620,786127,41367,487277,358358,149519,816409) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001039s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 42946 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 42946 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000816s ]