SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 427410 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 427410 [ RunTime:0.002372s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (81804,823063,380608,618112,660764,538360,129055,452437,633719,514395,628008,1010946,340515,55,123926,19334,327459,349441,388777,11782,100246,477793,693098,631069,759316,102394,538376,986448,301418,20499,902348,738964,953021,541564,680606,108828,571570,541501,684141,278316,471218,693312,20444,242118,250871,194858,365824,397651,890617,726261,841395,627709,290218,847145,151381,962972,833230,956680,845326,851712) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000927s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 427410 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 427410 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000738s ]