SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001615s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1025590 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1025590 [ RunTime:0.001924s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (510230,196686,972910,170203,89499,161160,640805,294495,941945,613124,679667,909442,838764,433455,615052,447321,806571,418400,993139,39956,390023,306210,460389,1033700,7198,216524,476248,820107,445510,906180,92222,523859,529284,651618,442595,140435,1045266,828611,498494,860391,648644,282107,709809,703477,312120,460512,101503,986956,1011733,849884,220030,783806,824386,732381,163069,995134,32364,489114,491944,768135) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1025590 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1025590 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]