SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003279s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 554023 LIMIT 1 [ RunTime:0.000472s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 554023 [ RunTime:0.001920s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (920838,898044,455404,585863,440032,481888,569509,819105,874852,721538,822061,298775,9325,679823,365037,1020429,1047706,1006425,483254,110382,988196,253825,443418,631142,50251,608353,821055,467103,995153,229392,749504,295240,326917,208958,778127,204521,83094,165293,301016,303171,170237,134989,1030677,239784,490134,291245,501100,640731,777282,997158,200527,555588,306511,514471,1023476,688101,544630,683336,417716,1030022) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 554023 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 554023 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]