SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017217 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017217 [ RunTime:0.002910s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (293487,789017,60631,861526,535466,887708,371917,554847,706952,201040,966531,490440,717942,875061,568620,901619,757194,497672,703887,433244,43511,311102,502260,207240,842089,656786,181756,260515,893069,334766,570782,935463,374839,11952,891327,440018,426483,980414,359192,562328,537730,293766,653634,346351,955983,898754,799212,1040640,388180,846014,128440,411601,86036,232062,471733,356626,843927,462198,800361,711808) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017217 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000903s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017217 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000391s ]