SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 392718 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 392718 [ RunTime:0.002097s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (422726,36486,747853,554645,223404,714846,83507,966119,544324,810981,607414,94572,969548,349349,788766,281985,574511,747522,937476,68738,156764,418677,583705,442909,524339,441893,943544,528259,723965,843980,1017293,732848,1043509,823708,176571,9959,819052,308148,209364,611243,168157,187879,410709,336858,925441,121683,28388,514949,395036,817039,278615,380219,561826,947147,264205,808986,6023,494184,526523,682440) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 392718 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000648s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 392718 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000616s ]