SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 805024 LIMIT 1 [ RunTime:0.000421s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 805024 [ RunTime:0.001930s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (909371,111757,510675,532692,996952,1034001,96845,657891,327838,9708,920984,783118,859706,1020180,294630,263223,474136,372014,836458,311903,330936,987168,758571,34125,754112,463963,388580,801849,622316,898194,292918,603660,836402,834926,892880,602926,563518,614297,475197,872181,995004,986640,684480,695492,600895,241535,863282,72284,446611,498859,262094,23449,310797,1028914,293444,753397,545546,222984,894858,435363) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001720s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 805024 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 805024 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]