SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 563896 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 563896 [ RunTime:0.002055s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (48409,944301,675945,523145,174149,614017,928280,292286,120128,838460,24070,852954,454342,1042120,282773,680795,109762,1045909,959530,669938,918443,686272,827023,531249,910229,866474,402188,749270,116681,719585,742413,841331,652453,222124,929204,478690,696094,2705,594588,94458,327382,793267,1041331,900265,5507,544589,994862,18372,974168,703170,158208,553179,807816,415640,496566,288447,19295,715460,578945,943235) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 563896 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 563896 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001314s ]