SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 575451 LIMIT 1 [ RunTime:0.000449s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 575451 [ RunTime:0.002138s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (193979,944138,597917,1041453,568081,602514,1000460,699119,80652,716581,658928,887018,948638,423908,283830,201557,303792,55653,166161,256404,188553,988696,234261,802128,129479,248106,184123,356768,750612,391493,120519,363200,691656,663241,669911,272147,415701,25930,941950,839725,433933,322436,458975,828425,951295,836680,981751,655139,16565,846224,732248,854374,770247,748958,717136,350988,668230,341886,771108,926505) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000973s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 575451 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 575451 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]