SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001374s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 433834 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 433834 [ RunTime:0.001771s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (480434,76178,113932,472323,565266,954856,115572,913641,351386,361413,350683,491825,907092,752620,584603,455579,161409,757717,294470,1003780,493951,489155,702108,156417,109640,6900,783555,274782,29709,657032,534186,742804,222142,855849,297889,647153,954561,223428,536180,1035138,187511,312833,714080,473959,476593,537579,79555,292329,442842,301709,148039,891520,272802,651589,650298,192698,630298,938755,936531,269445) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 433834 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 433834 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000827s ]