SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 525033 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 525033 [ RunTime:0.003572s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (343975,461429,230401,291050,13268,488495,564309,220159,189125,170751,899509,202849,1044817,300496,417017,769322,329257,950077,517540,997567,127653,838952,564685,171509,542698,674924,627882,570352,280834,221193,773185,331533,274065,555515,155099,898257,277483,828145,487248,560358,922390,933817,436492,381326,233088,273541,784188,63078,779625,361659,67574,818491,31808,803409,516207,871483,872790,686782,538319,789776) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002239s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 525033 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001582s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 525033 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]