SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1038909 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1038909 [ RunTime:0.001543s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (649293,369045,895873,259689,667823,962136,289618,421461,274732,923933,904603,817812,212243,618753,1016985,741413,351163,997206,658159,92830,482023,459796,845796,19688,729236,18077,643572,558681,384925,616613,612423,366489,187929,983859,578763,183354,732858,417656,381358,426397,422666,536849,229897,928143,474339,471242,142125,942530,10981,987296,922566,388127,784952,911762,613647,411875,670775,571331,642757,628195) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1038909 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1038909 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000462s ]