SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003079s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 422660 LIMIT 1 [ RunTime:0.000796s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 422660 [ RunTime:0.002489s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1030997,13812,729599,258011,858649,703802,598539,941501,878761,410676,384458,58119,1034447,926737,418656,586825,899037,976274,737695,1011680,769437,1001096,776471,514959,83884,478482,252968,119792,917017,127156,365103,905160,670772,24938,1019334,609815,502496,59480,217810,376697,309070,929716,894049,825748,1038187,793412,650665,343806,836656,885249,22,20945,519489,845499,907135,825354,250198,115875,889308,466020) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 422660 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 422660 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000872s ]