SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001026s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042933 LIMIT 1 [ RunTime:0.000603s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042933 [ RunTime:0.001670s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (457789,921891,272297,190341,612180,400348,705175,807312,338700,979969,672056,412082,700339,833093,391725,933634,962478,501804,493691,207527,797743,1018851,531299,380502,613387,320223,701647,985401,117933,863021,909737,668889,981919,632790,130777,476040,672102,468053,880791,576395,65683,826748,60846,1020938,986477,120603,550563,475163,1007713,851286,63947,205452,916282,465849,258603,713968,702579,811018,357174,484427) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001315s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042933 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042933 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]