SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001365s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 782812 LIMIT 1 [ RunTime:0.000297s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 782812 [ RunTime:0.001603s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (74683,106940,345671,480262,836674,948070,511200,501613,122692,39482,87154,251514,883491,462017,124067,632360,694685,135231,321363,326587,993998,10750,1037090,143971,934262,572623,917059,337133,154077,68620,602052,878153,463129,721323,1046449,566841,803263,521275,103895,701583,570394,255436,778924,375963,934587,586623,809719,805822,148317,635894,510738,47476,876288,865496,695150,596845,407455,407538,226516,747473) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001057s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 782812 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 782812 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000484s ]