SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 444343 LIMIT 1 [ RunTime:0.000291s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 444343 [ RunTime:0.001450s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (465755,400568,647286,788509,519854,904893,876613,375928,574761,776310,1005056,890304,22391,97520,324683,1009577,634330,145329,760374,397013,801163,818591,6123,151119,575843,677825,267324,766053,784745,643990,951668,228807,171138,609254,602481,632467,503137,515756,410113,613997,423908,227894,944627,223630,428404,222302,978870,371949,854018,666618,714792,1007678,91981,32162,731561,907475,108712,407161,100062,740902) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001818s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 444343 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 444343 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000476s ]