SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001949s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 820313 LIMIT 1 [ RunTime:0.001024s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 820313 [ RunTime:0.002992s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (628083,56741,938761,113412,1001142,369840,165415,642539,1018176,953724,841828,14473,25125,966322,418154,595686,932379,118522,36536,60314,830633,782832,737047,55857,859658,1047824,864444,471784,711662,439637,236225,530137,978294,510603,404676,807675,764999,57836,957117,501058,575267,784559,242690,23009,157896,87153,114896,621831,770345,691427,153358,833126,270511,609581,624589,612679,961293,990856,972011,99269) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001639s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 820313 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 820313 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001070s ]