SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001091s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 516211 LIMIT 1 [ RunTime:0.000813s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 516211 [ RunTime:0.002365s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (757572,225539,749531,82504,1037454,108990,694029,1007442,266859,79111,125528,765894,170671,202834,231224,210147,357587,406170,756038,851862,1036897,981113,968474,554748,732547,277751,970893,101276,1040393,159716,468549,696529,379072,446451,745978,841999,938147,581042,398357,513602,934551,310986,381056,351641,680869,703564,49685,864721,898145,330034,703992,513612,172308,370532,391730,68531,972040,53298,998520,255086) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000993s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 516211 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000606s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 516211 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001063s ]