SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042947 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042947 [ RunTime:0.002003s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (183997,825918,338548,742412,688162,589401,201240,283532,646959,1037597,671827,847368,369290,610432,137269,201738,411144,71215,111505,37224,945059,255825,790046,882823,579371,174590,694990,9091,677806,459736,132758,981525,742135,857052,650187,687318,895555,916252,681902,51066,1025249,670258,38031,932907,703744,635098,1048899,287331,541299,155856,490828,671392,44937,521342,572835,635951,814061,442162,954322,715810) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000989s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042947 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042947 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000455s ]