SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 457104 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 457104 [ RunTime:0.003756s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (213544,863437,107835,692271,168281,858979,414598,6542,369831,547694,371573,235005,280422,596365,381561,271047,252836,318692,812368,156159,1018029,491293,892370,770246,145142,578553,982473,158715,145148,628479,148254,1015500,491991,348225,104808,348441,930170,816990,77025,195350,145234,677084,366631,21633,803013,319858,754685,798471,181002,267538,659491,285748,496521,505184,797797,194823,571091,884492,732383,1004616) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003224s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 457104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000613s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 457104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003431s ]