SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 425022 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 425022 [ RunTime:0.001912s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (508662,744900,514087,920199,986580,356569,150274,327356,944044,591274,253844,379062,597653,212030,722099,235154,535256,583367,251183,732938,625827,510582,905793,783747,760224,1041615,507217,415899,12520,512466,297274,676818,516928,855246,108828,443168,787766,11887,377979,664367,351055,330062,365651,969374,751335,660922,907338,906948,882677,479794,656179,935720,80408,375331,437685,195529,141752,721621,996277,377361) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 425022 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 425022 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]