SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001398s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 193419 LIMIT 1 [ RunTime:0.000537s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 193419 [ RunTime:0.003295s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (772320,78022,342331,868427,73764,491819,619579,203051,475173,676482,426888,299912,1001224,811955,108647,225221,304368,499884,1026248,734214,833495,241836,949305,418189,564367,640070,293130,589806,492996,392694,15031,433514,711433,539203,890344,934591,252812,359423,817165,1027045,216824,901876,430073,836445,596766,104328,232401,818372,839743,955878,854308,128851,63421,116148,608222,494138,996501,726842,28264,1046421) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 193419 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 193419 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000473s ]