SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 512663 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 512663 [ RunTime:0.001471s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (486391,392003,569629,250921,549663,725264,653790,57193,919176,554935,803293,338497,409072,564356,942935,85688,322272,757406,906810,547821,671545,1013546,771998,198218,599438,859223,880953,219603,906191,283074,281447,527990,268112,830763,390373,145803,147524,981349,276981,1030627,26872,835916,597011,666416,20573,273954,562179,26519,322707,962764,952555,325944,208420,516559,800540,357817,213810,953868,580587,952932) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001039s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 512663 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 512663 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]