SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001430s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 573704 LIMIT 1 [ RunTime:0.001160s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 573704 [ RunTime:0.002907s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (952552,423498,322071,327083,725558,950450,174650,133863,923545,251633,572922,748209,834483,654970,29084,644765,170698,383185,781723,578041,475051,702307,180977,444820,562067,876982,636520,679664,815393,369492,270954,263731,959924,932582,120726,853419,831088,327753,270144,300653,98616,279776,483704,583580,156671,933117,262561,981205,696748,146387,228599,575584,482672,289263,666380,251333,606078,239321,1027807,613001) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 573704 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 573704 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000852s ]