SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 289629 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 289629 [ RunTime:0.001812s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (402621,715104,899523,726028,1020270,979515,609409,13185,863622,312902,231789,109543,875612,5992,972755,929262,291870,187182,399426,756056,859368,909943,277161,802724,44473,748516,811122,479562,497456,787307,237080,939247,809102,68296,530937,346141,547829,91179,916700,391045,863321,312511,926380,773941,877604,105451,908380,340981,275574,774625,645326,512320,49291,211362,332508,473115,1018986,144512,699213,846360) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001089s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 289629 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 289629 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000443s ]