SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 316384 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 316384 [ RunTime:0.003390s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (974321,266053,186302,288417,250106,110196,159064,583414,172100,227387,1044490,254995,90158,910826,705428,688318,193780,241522,1040752,439374,269720,169798,755521,750921,558871,185292,698219,265281,537702,592467,630094,550302,329992,83912,164310,260338,870025,934690,970484,386981,1018911,574659,139787,995659,266726,971653,683884,874394,841028,1040597,525585,135346,1019314,642709,667781,843217,721290,950814,341674,899015) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004110s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 316384 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000600s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 316384 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002245s ]