SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001416s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012571 LIMIT 1 [ RunTime:0.000456s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012571 [ RunTime:0.004839s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (902023,721213,326521,381001,654682,359298,31216,1036332,100136,917460,793855,675812,11526,57454,96411,960279,99287,658884,1018527,568323,255100,485673,509928,155918,837953,325275,1000508,459128,1030959,840245,206670,707718,459078,111363,209262,547973,703677,30684,3881,951442,585749,511314,823892,122576,95567,952416,744516,609803,72893,420918,786755,249600,602004,313171,819308,599685,544439,192764,699022,89597) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012571 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012571 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]