SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001608s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 584181 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 584181 [ RunTime:0.001862s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (707498,1013155,1047075,17886,601096,726208,787104,262243,42087,921019,102444,945045,692819,156416,199787,179081,357266,346350,242754,724688,714832,967889,814891,702090,777633,373947,679413,785827,758214,1043829,254331,162605,817947,310097,797365,1024299,196400,799944,574571,274432,734596,773376,340017,543292,731088,84282,788718,440882,1035413,472028,949686,719616,250300,1030713,374660,161779,561615,39368,407641,534126) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001017s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 584181 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 584181 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000894s ]