SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1037828 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1037828 [ RunTime:0.001785s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (237072,627362,346994,637685,847030,769448,657015,111076,523724,704333,565848,380243,138716,318325,628586,662102,769080,577481,956863,557033,905912,937058,55214,588941,678342,17770,660513,962062,746412,574745,886770,540137,827598,664310,161043,676011,386443,304186,564242,467399,166323,396621,1014207,145345,457172,366519,366311,721529,476018,71447,231518,507969,876707,885083,976146,209447,1010129,932807,441997,231202) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1037828 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1037828 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001398s ]