SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022967 LIMIT 1 [ RunTime:0.000417s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022967 [ RunTime:0.001937s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (699548,300203,938713,813579,516608,132574,784769,246310,965729,600405,812760,269262,767044,570665,473756,398063,518001,788783,654235,751351,659207,646787,239909,512215,579858,833345,377729,285643,251280,326574,796560,62383,226200,93418,894254,4501,157022,437230,269122,48668,433092,451493,107052,704526,287485,981425,262191,583909,623027,107998,254514,876977,78897,224520,132721,339137,1030872,267000,447595,470385) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022967 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022967 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000706s ]