SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 445889 LIMIT 1 [ RunTime:0.000425s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 445889 [ RunTime:0.001676s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (394026,237523,550960,656988,619195,605041,584631,848800,514249,996832,526525,40672,940278,771450,892459,636165,913685,475629,92017,104331,52329,978253,366900,714596,598965,670404,247989,995099,424354,993820,404740,62323,769197,867766,619198,143875,940962,449145,504403,959342,468700,675803,1002522,510501,416869,619584,864937,238078,851504,1023707,614432,252255,305870,51814,519192,272742,499933,109723,249296,631204) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002792s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 445889 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 445889 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000668s ]