SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 565410 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 565410 [ RunTime:0.001624s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (718219,390639,512977,375155,217772,306187,711244,605943,982638,440171,341122,185251,896283,18469,956329,314026,509769,726998,972138,965462,473788,994657,234174,101880,932448,523029,935042,401532,917331,756155,555220,119526,587807,74723,464413,375275,2700,411010,82387,410555,743574,1047054,1039442,338730,987722,679355,774410,644199,77406,320672,403178,392693,1002394,231733,924534,508011,437073,80574,990923,953049) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000948s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 565410 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 565410 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000411s ]